package com.example.demo.mapper;

import com.example.demo.entity.Finance;
import com.example.demo.entity.Furniture;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface financemapper {
    //添加一个财政信息
    @Insert("insert into finance(ordername,price,buyuser,created_user,created_time,modified_user,modified_time)values (#{ordername},#{price},#{buyuser},#{createdUser},#{createdTime},#{modifiedUser},#{modifiedTime})")
    int add(Finance finance);
    //查询财务信息
    //家具分页查询功能
    List<Finance> page(int page, int size, String query);
    //条件查询
    List<Finance> search(String query);
    //查询总收益
    int money();
}
